Tabela Event

Definicja tabeli Event

Name

Event

Code

Event

Comment

 


Lista kolumn tabeli Event

Name

Code

DisabledLevel

DisabledLevel

EventID

EventID

EpisodeID

EpisodeID

OrgUnitID

OrgUnitID

PersonnelTypeID

PersonnelTypeID

WaitingListID

WaitingListID

EventSessionID

EventSessionID

RescueServiceID

RescueServiceID

MZCodeID

MZCodeID

MalignantTumourId

MalignantTumourId

ExternalEventID

ExternalEventID

HospitalStayDay

HospitalStayDay

StartDT

StartDT

StopDT

StopDT

PersonnelNPWZ

PersonnelNPWZ

PersonnelPESEL

PersonnelPESEL

RUMDT

RUMDT

RUMNo

RUMNo

RUMType

RUMType

TransportDestination

TransportDestination

TransportSurcharge

TransportSurcharge

AmbulatoryEventType

AmbulatoryEventType

EventSubType

EventSubType

ToDelete

ToDelete

CurrentAccountDataStatusID

CurrentAccountDataStatusID

NFZEventID

NFZEventID

SorAdmissionReason

SorAdmissionReason

SurgeryMode

SurgeryMode

SurgeryDate

SurgeryDate

PhysicalAbilityLevel

PhysicalAbilityLevel

LactateLevel

LactateLevel

ContinuationOfTreatment

ContinuationOfTreatment

SamplingDate

SamplingDate

Height

Height

Weight

Weight

IsPaperPrescriptionIssued

IsPaperPrescriptionIssued

IsWomanPregnant

IsWomanPregnant

SmokedTobaccoProductCode

SmokedTobaccoProductCode


Kolumna DisabledLevel tabeli Event

Definicja kolumny DisabledLevel tabeli Event

Name

DisabledLevel

Code

DisabledLevel

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna EventID tabeli Event

Definicja kolumny EventID tabeli Event

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

Yes

Comment

 


Kolumna EpisodeID tabeli Event

Definicja kolumny EpisodeID tabeli Event

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(20)

Mandatory

No

Comment

 


Kolumna OrgUnitID tabeli Event

Definicja kolumny OrgUnitID tabeli Event

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonnelTypeID tabeli Event

Definicja kolumny PersonnelTypeID tabeli Event

Name

PersonnelTypeID

Code

PersonnelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WaitingListID tabeli Event

Definicja kolumny WaitingListID tabeli Event

Name

WaitingListID

Code

WaitingListID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventSessionID tabeli Event

Definicja kolumny EventSessionID tabeli Event

Name

EventSessionID

Code

EventSessionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RescueServiceID tabeli Event

Definicja kolumny RescueServiceID tabeli Event

Name

RescueServiceID

Code

RescueServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MZCodeID tabeli Event

Definicja kolumny MZCodeID tabeli Event

Name

MZCodeID

Code

MZCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MalignantTumourId tabeli Event

Definicja kolumny MalignantTumourId tabeli Event

Name

MalignantTumourId

Code

MalignantTumourId

Data Type

NUMBER(10)

Mandatory

No

Comment

ID nowotworu zlosliwego


Kolumna ExternalEventID tabeli Event

Definicja kolumny ExternalEventID tabeli Event

Name

ExternalEventID

Code

ExternalEventID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna HospitalStayDay tabeli Event

Definicja kolumny HospitalStayDay tabeli Event

Name

HospitalStayDay

Code

HospitalStayDay

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Event

Definicja kolumny StartDT tabeli Event

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli Event

Definicja kolumny StopDT tabeli Event

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna PersonnelNPWZ tabeli Event

Definicja kolumny PersonnelNPWZ tabeli Event

Name

PersonnelNPWZ

Code

PersonnelNPWZ

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna PersonnelPESEL tabeli Event

Definicja kolumny PersonnelPESEL tabeli Event

Name

PersonnelPESEL

Code

PersonnelPESEL

Data Type

VARCHAR2(11)

Mandatory

No

Comment

 


Kolumna RUMDT tabeli Event

Definicja kolumny RUMDT tabeli Event

Name

RUMDT

Code

RUMDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna RUMNo tabeli Event

Definicja kolumny RUMNo tabeli Event

Name

RUMNo

Code

RUMNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna RUMType tabeli Event

Definicja kolumny RUMType tabeli Event

Name

RUMType

Code

RUMType

Data Type

CHAR(1)

Mandatory

No

Comment

 


Kolumna TransportDestination tabeli Event

Definicja kolumny TransportDestination tabeli Event

Name

TransportDestination

Code

TransportDestination

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna TransportSurcharge tabeli Event

Definicja kolumny TransportSurcharge tabeli Event

Name

TransportSurcharge

Code

TransportSurcharge

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna AmbulatoryEventType tabeli Event

Definicja kolumny AmbulatoryEventType tabeli Event

Name

AmbulatoryEventType

Code

AmbulatoryEventType

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna EventSubType tabeli Event

Definicja kolumny EventSubType tabeli Event

Name

EventSubType

Code

EventSubType

Data Type

VARCHAR2(3)

Mandatory

No

Comment

 


Kolumna ToDelete tabeli Event

Definicja kolumny ToDelete tabeli Event

Name

ToDelete

Code

ToDelete

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna CurrentAccountDataStatusID tabeli Event

Definicja kolumny CurrentAccountDataStatusID tabeli Event

Name

CurrentAccountDataStatusID

Code

CurrentAccountDataStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NFZEventID tabeli Event

Definicja kolumny NFZEventID tabeli Event

Name

NFZEventID

Code

NFZEventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna SorAdmissionReason tabeli Event

Definicja kolumny SorAdmissionReason tabeli Event

Name

SorAdmissionReason

Code

SorAdmissionReason

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Powód udzielenia swiadczenia w SOR


Kolumna SurgeryMode tabeli Event

Definicja kolumny SurgeryMode tabeli Event

Name

SurgeryMode

Code

SurgeryMode

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Tryb zabiegu


Kolumna SurgeryDate tabeli Event

Definicja kolumny SurgeryDate tabeli Event

Name

SurgeryDate

Code

SurgeryDate

Data Type

DATE

Mandatory

No

Comment

Data i godzina zabiegu


Kolumna PhysicalAbilityLevel tabeli Event

Definicja kolumny PhysicalAbilityLevel tabeli Event

Name

PhysicalAbilityLevel

Code

PhysicalAbilityLevel

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Sprawnosc fizyczna wedlug ZUBRODA-ECOG-WHO


Kolumna LactateLevel tabeli Event

Definicja kolumny LactateLevel tabeli Event

Name

LactateLevel

Code

LactateLevel

Data Type

NUMBER(5,2)

Mandatory

No

Comment

Poziom mleczanów w osoczu krwi wykazywany w jednostce mmol/L


Kolumna ContinuationOfTreatment tabeli Event

Definicja kolumny ContinuationOfTreatment tabeli Event

Name

ContinuationOfTreatment

Code

ContinuationOfTreatment

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Kod dalszej opieki nad pacjentem


Kolumna SamplingDate tabeli Event

Definicja kolumny SamplingDate tabeli Event

Name

SamplingDate

Code

SamplingDate

Data Type

DATE

Mandatory

No

Comment

Data pobrania materialu


Kolumna Height tabeli Event

Definicja kolumny Height tabeli Event

Name

Height

Code

Height

Data Type

NUMBER(7,4)

Mandatory

No

Comment

wzrost pacjenta w dniu udzielenia swiadczenia


Kolumna Weight tabeli Event

Definicja kolumny Weight tabeli Event

Name

Weight

Code

Weight

Data Type

NUMBER(7,4)

Mandatory

No

Comment

waga pacjenta w dniu udzielenia swiadczenia


Kolumna IsPaperPrescriptionIssued tabeli Event

Definicja kolumny IsPaperPrescriptionIssued tabeli Event

Name

IsPaperPrescriptionIssued

Code

IsPaperPrescriptionIssued

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wystawiono recepte papierowa


Kolumna IsWomanPregnant tabeli Event

Definicja kolumny IsWomanPregnant tabeli Event

Name

IsWomanPregnant

Code

IsWomanPregnant

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Kolumna SmokedTobaccoProductCode tabeli Event

Definicja kolumny SmokedTobaccoProductCode tabeli Event

Name

SmokedTobaccoProductCode

Code

SmokedTobaccoProductCode

Data Type

VARCHAR2(2)

Mandatory

No

Comment

kod wyrobów tytoniowych stosowanych przez pacjenta POZ


Lista kluczy tabeli Event

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Event

Definicja klucza Identifier_1 tabeli Event

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment